/* * * * M A P V I S I O N   L I C E N S E  *****************************************************************
 *
 * This MapVision software is © Filip Zavadil 2013. It is licensed under the LGPL license.
 * This MapVision software dynamically links to unmodified Qt5 Library.
 *
 * The Qt5 Library is © 2013 Qt® and/or its subsidiary(-ies), and is licensed under the
 * GNU Lesser General Public License version 2.1 with Qt® LGPL exception version 1.1.
 * Qt5 library is free software; you can redistribute it and/or modify it under the terms of the
 * GNU Lesser General Public License, version 2.1, as published by the Free Software Foundation.
 * Qt5 library is provided “AS IS”, without WARRANTIES OR CONDITIONS OF ANY KIND, EITHER EXPRESS OR
 * IMPLIED INCLUDING, WITHOUT LIMITATION, ANY WARRANTIES OR CONDITIONS OF TITLE, NON-INFRINGEMENT,
 * MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
 *
 * As an additional permission to the GNU Lesser General Public License version 2.1, the object
 * code form of a “work that uses the Library” may incorporate material from a header file that is
 * part of the Library. You may distribute such object code under terms of your choice,
 * provided that: (i) the header files of the Library have not been modified; and (ii)
 * the incorporated material is limited to numerical parameters, data structure layouts, accessors,
 * macros, inline functions and templates; and (iii) you comply with the terms of Section 6 of the
 * GNU Lesser General Public License version 2.1.
 *
 * Moreover, you may apply this exception to a modified version of the Library, provided that such
 * modification does not involve copying material from the Library into the modified Library’s header
 * files unless such material is limited to (i) numerical parameters; (ii) data structure layouts;
 * (iii) accessors; and (iv) small macros, templates and inline functions of five lines or less in length.
 *
 * Furthermore, you are not required to apply this additional permission to a modified version of the Library.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this package;
 * if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

 * The source code for Qt 5.X SDK is available from Qt Project here:
 * http://download.qt-project.org/official_releases/qtcreator/2.7/2.7.0/qt-creator-2.7.0-src.zip.
 *
 * ****************************** M A P V I S I O N    S O F T W A R E  ************************************
 *
 * Author:       Filip Zavadil
 * Description:  Software for displaying and exporting map tiles.
 * The sources and executables of MapVision software are available:
 *    - from project hosting on CodePlex.com :   http://mapvision.codeplex.com
 *    - from GIT repositories on Gitorious.org:  https://gitorious.org/mapvision
 * Visit MapVision fanpage on Facebook.com:      https://www.facebook.com/pages/Mapvision/631827753513935
 *
 * *********************************************************************************************************
*/

#include "dialoglayersqlite.h"
#include "ui_dialoglayersqlite.h"
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>

DialogLayerSQLite::DialogLayerSQLite(QWidget *parent, Layer * layer_) :
    QDialog(parent),  ui(new Ui::DialogLayerSQLite), layer(layer_)
{
    ui->setupUi(this);
    this->setWindowIcon(QIcon("images/buttons/addTilesSQL.svg"));
    this->setWindowTitle(tr("Add SQLite layer"));
}

DialogLayerSQLite::~DialogLayerSQLite()
{
    delete ui;
}

void DialogLayerSQLite::on_pushButtonOpen_clicked()
{
    QString path=layer->settings.value("layer/SQLite").toString();
    QString dir = QFileDialog::getOpenFileName(this, tr("Open SQLite database"),
                                               path,
                                               tr("SQLite database (*.mbtiles *.sqlitedb)"));

    QFile file(dir);

    if (file.open(QIODevice::ReadWrite) && dir != "" && connect(dir) )
    {

        ui->sourcePath->setText(dir);
       // this->setOrigin(dir);
        layer->settings.setValue("layer/SQLite",dir);
        ui->layerName->setText(dir.mid(dir.lastIndexOf("/")+1,-1));

    }
    else
    {
        emit layer->sendMessagePublic("<span style=\"color: #680000;\">"+ tr(" it is not selected a valid SQLite database")+ "</span>");
    }

}

void DialogLayerSQLite::on_pushButtonAccepted_clicked()
{
    if (ui->sourcePath->text() == "")
    {
        QMessageBox msgBox;
        msgBox.setText(tr("Source cannot be empty"));
        msgBox.exec();
        on_pushButtonOpen_clicked();
    }
    else if (ui->layerName->text().remove(" ") == "")
    {
        QMessageBox msgBox;
        msgBox.setText(tr("LayerName cannot be empty"));
        msgBox.exec();
    }
    else
    {
        layer->setLayerName(ui->layerName->text());
        layer->setSource(ui->sourcePath->text());
        layer->getMapView()->setZoom(ui->spinBoxOriginZoom->value());
        layer->getMapView()->setCenterLonLat(ui->lineEditOriginWGS->text());
        layer->setOrigin(layer->getMapView()->getCenterLonLat(),layer->getMapView()->getZoom());
        layer->setLayerType(Layer::MBtiles);
        layer->YaxisOrigin = ZavaProj::BOTTOM;
        this->accept();
    }
}

void DialogLayerSQLite::on_pushButtonReject_clicked()
{
    this->reject();
}

void DialogLayerSQLite::on_pushButtonUseCurrentOrigin_clicked()
{
    ui->lineEditOriginWGS->setText(layer->zavaProj.lonlat2dms(layer->getMapView()->getCenterLonLat()));
    ui->spinBoxOriginZoom->setValue(layer->getMapView()->getZoom());
}

bool DialogLayerSQLite::connect(QString path)
{

    QSqlDatabase database;
    database = QSqlDatabase::addDatabase("QSQLITE","temp");
    database.setDatabaseName(path);
    if (!database.open())
    {
        QMessageBox msgBox;
        msgBox.setText(tr("Database connection cannot be established! ") + database.lastError().text());
        msgBox.exec();

        return false;
    }
    else
    {

        QSqlQuery *query=new QSqlQuery(database);
        QPoint outPoint;

        query->exec("SELECT MIN(zoom_level) FROM tiles");
        query->first();
        int minZoom = query->value(0).toInt();

        query->exec("SELECT AVG(tile_row), AVG(tile_column) FROM tiles WHERE zoom_level = "+QString::number(minZoom)+";");
        while (query->next()) {
            outPoint=QPoint(query->value(1).toInt(),query->value(0).toInt());
        }

        ui->lineEditOriginWGS->setText(layer->zavaProj.lonlat2dms(layer->zavaProj.tileFormat2lonlat(outPoint,minZoom,ZavaProj::BOTTOM)));
        ui->spinBoxOriginZoom->setValue(minZoom);


        database.close();

        return true;
    }
}
